package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "aqb_pay_internal", simpleName = "", engine = MysqlDriver.InnoDB, comment = "AQB内部户账户支付")
public class _DDL_AqbPayInternal {

    @_DDL_Primary()
    @_DDL_Column(name = "PAY_ORDER_NO", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "支付订单号")
    private String payOrderNo;

    @_DDL_Column(name = "TRADE_SSN", type = SqlType.VARCHAR, size = 30, comment = "交易流水号")
    private String tradeSsn;

    @_DDL_Column(name = "TRANS_AMT", type = SqlType.VARCHAR, size = 15, nullable = false, comment = "交易金额，单位：元")
    private String transAmt;

    @_DDL_Column(name = "DIY_FEE", type = SqlType.VARCHAR, size = 15, nullable = false, comment = "自定义手续费，单位：元")
    private String diyFee;

    @_DDL_Column(name = "SLAVE_MER_ID", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "订单归属商户号")
    private String slaveMerId;

    @_DDL_Column(name = "SETTLE_DATE", type = SqlType.VARCHAR, size = 10, nullable = false, comment = "清算日期")
    private String settleDate;

    @_DDL_Column(name = "MER_ORDER_NO", type = SqlType.VARCHAR, size = 50, comment = "商户订单号")
    private String merOrderNo;

    @_DDL_Column(name = "TRANS_SERIAL_NO", type = SqlType.VARCHAR, size = 50, comment = "交易流水号")
    private String transSerialNo;

    @_DDL_Column(name = "TRANS_TIME", type = SqlType.VARCHAR, size = 19, comment = "交易时间")
    private String transTime;

    @_DDL_Column(name = "TRANS_STATUS", type = SqlType.VARCHAR, size = 10, comment = "交易状态，init：初始、fail：失败、succ：成功、unknow：未知")
    private String transStatus;

    @_DDL_Column(name = "ERROR_CODE", type = SqlType.VARCHAR, size = 20, comment = "错误码")
    private String errorCode;

    @_DDL_Column(name = "ERROR_MSG", type = SqlType.VARCHAR, size = 100, comment = "错误信息")
    private String errorMsg;

    @_DDL_Column(name = "CREATE_TIME", type = SqlType.VARCHAR, size = 19, nullable = false, comment = "创建时间")
    private String createTime;

    @_DDL_Column(name = "UPDATE_TIME", type = SqlType.VARCHAR, size = 19, comment = "更新时间")
    private String updateTime;

}
